/*
 Navicat Premium Data Transfer

 Source Server         : MySQL
 Source Server Type    : MySQL
 Source Server Version : 80013
 Source Host           : localhost:3306
 Source Schema         : MBPO

 Target Server Type    : MySQL
 Target Server Version : 80013
 File Encoding         : 65001

 Date: 05/04/2019 15:16:57
*/

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `username` varchar(15) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of admin
-- ----------------------------
BEGIN;
INSERT INTO `admin` VALUES ('admin', 'admin', 'admin1');
COMMIT;

-- ----------------------------
-- Table structure for competitor
-- ----------------------------
DROP TABLE IF EXISTS `competitor`;
CREATE TABLE `competitor` (
  `stuNumber` varchar(15) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `matchId` varchar(8) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`stuNumber`,`matchId`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of competitor
-- ----------------------------
BEGIN;
INSERT INTO `competitor` VALUES ('1', '20190401');
INSERT INTO `competitor` VALUES ('123', '20190401');
INSERT INTO `competitor` VALUES ('2', '20190401');
INSERT INTO `competitor` VALUES ('qwe', '20190401');
COMMIT;

-- ----------------------------
-- Table structure for matchs
-- ----------------------------
DROP TABLE IF EXISTS `matchs`;
CREATE TABLE `matchs` (
  `matchId` varchar(8) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '比赛编号',
  `matchName` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `beginTime` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `endTime` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `maxNumber` int(3) NOT NULL,
  `isLock` varchar(1) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`matchId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of matchs
-- ----------------------------
BEGIN;
INSERT INTO `matchs` VALUES ('20190401', '河北省大学生算法竞赛', '2019-04-01', '2019-04-02', 120, '0', '<a title=\"报名\" class=\"layui-btn layui-btn layui-btn-xs\" lay-event=\"sign\">报名</a>');
COMMIT;

-- ----------------------------
-- Table structure for notice
-- ----------------------------
DROP TABLE IF EXISTS `notice`;
CREATE TABLE `notice` (
  `noticeId` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `noticeTitle` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `noticeDesc` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`noticeId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of notice
-- ----------------------------
BEGIN;
INSERT INTO `notice` VALUES (1, '公告1', '眼过千遍不如手过一遍！\r书看千行不如手敲一行！\r手敲千行不如单步一行！');
INSERT INTO `notice` VALUES (2, '公告1', '眼过千遍不如手过一遍！\r书看千行不如手敲一行！\r手敲千行不如单步一行！');
INSERT INTO `notice` VALUES (3, '公告1', '眼过千遍不如手过一遍！\r书看千行不如手敲一行！\r手敲千行不如单步一行！');
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `username` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `password` varchar(20) COLLATE utf8_bin NOT NULL,
  `nickname` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `college` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `major` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES ('1', '1', '1', '1', '1');
INSERT INTO `user` VALUES ('123', '123', '123', '123', '123');
INSERT INTO `user` VALUES ('2', '2', '2', '2', '2');
INSERT INTO `user` VALUES ('qwe', 'qwe', 'qwe', 'qwe', 'qwe');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
